UPDATE C1_USER_GROUP_ROLE SET END_DATE = SYSDATE, DATA_STATE_CODE = '0' WHERE
INSTR(','||:userGroupRoleIds||',', ','||USER_GROUP_ROLE_ID||',') > 0